CREATE PROCEDURE [dbo].[BAEImisDuesProductGetSourceFieldFromNameAll]
      -- Add the parameters for the stored procedure here
      @field varchar(4000),
      @ID varchar(10)
AS
BEGIN
      -- SET NOCOUNT ON added to prevent extra result sets from
      -- interfering with SELECT statements.
      SET NOCOUNT ON;
    Declare @imisTableName as varchar(56);
    SET @imisTableName = 'Name_All';

   Declare @sql nvarchar(4000);
      SET @sql = 'SELECT ' + REPLACE(@field, 'Name_All' ,@imisTableName) + ' FROM Name_All where Name_All.ID = ''' + @ID + ''';'

      exec sp_executesql @sql;
END

GO